from django.db import models

# Create your models here.

class BookinfoModels(models.Model):
    """ 定义书籍类 """
    btitle = models.CharField(max_length=20,verbose_name='名称',help_text="书籍标题")
    bpub_date = models.DateField(verbose_name='发布日期')
    bread = models.IntegerField(default=0,verbose_name='阅读量')
    bcomment = models.IntegerField(default=0,verbose_name='评论量')
    is_delete = models.BooleanField(default=False,verbose_name='逻辑删除')

    class Meta:
        db_table = 'tb_books'                #指明数据库表明
        verbose_name = '图书'                 #在admin站点中显示的名称
        verbose_name_plural = verbose_name   #显示负载名称
    def __str__(self):
        """定义每个数据对象的显示信息"""
        return self.btitle


class HeroinfoModels(models.Model):
    """ 定义英雄类 """
    GENDER_CHOICES = (
        (0,'female'),
        (1,'male')
    )

    hname = models.CharField(max_length=20,verbose_name='名称')
    hgender = models.SmallIntegerField(choices=GENDER_CHOICES,verbose_name='性别')
    hcomment = models.CharField(max_length=200,null=True,verbose_name='描述信息')
    hbook = models.ForeignKey(BookinfoModels,on_delete=models.CASCADE,verbose_name='图书') #外键
    is_delete = models.BooleanField(default=False,verbose_name='逻辑删除')

    class Meta:
        db_table = 'tb_heros'
        verbose_name = '英雄'
        verbose_name_plural = verbose_name
    def __str__(self):
        return self.hname
